Information and Data Quality in Spreadsheets

نویسنده

  • Patrick O'Beirne
چکیده

The quality of the data in spreadsheets is less discussed than the structural integrity of the formulas. Yet it is an area of great interest to the owners and users of the spreadsheet. This paper provides an overview of Information Quality (IQ) and Data Quality (DQ) with specific reference to how data is sourced, structured, and presented in spreadsheets.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Exact and Near-miss Clone Detection in Spreadsheets

Spreadsheets are used extensively in business, in many domains. The applicability of software engineering methods to spreadsheets has been a topic of research for several years [2], but the main focus has been on analyzing the formulas, and not on analyzing the data in the spreadsheets. One of the factors that plays a role in spreadsheet data quality is the occurrence of clones in the spreadshe...

متن کامل

Breviz: Visualizing Spreadsheets using Dataflow Diagrams

Spreadsheets are used extensively in industry, often for business critical purposes. In previous work we have analyzed the information needs of spreadsheet professionals and addressed their need for support with the transition of a spreadsheet to a colleague with the generation of data flow diagrams. In this paper we describe the application of these data flow diagrams for the purpose of unders...

متن کامل

Breviz: Spreadsheet Visualization and Quality Analysis

Thanks to their flexibility and intuitive programming model, spreadsheets are widely used in industry, often for business-critical applications. Similar to software developers, professional spreadsheet users demand support for understanding spreadsheets, and analyzing their quality. This paper describes Breviz, a tool that visualizes spreadsheets as leveled dataflow diagrams, showing users all ...

متن کامل

Spreadsheets for Geothermal Water and Gas Geochemistry

Two Excel spreadsheets released with this paper support many of the common graphical analyses of water and gas chemistry used to interpret hot spring, fumarole and well samples in geothermal exploration and development. Cross-plots and ternary diagrams are generated from measured concentrations of chemical species using formulas based on equilibrium reactions and empirical relationships. Typica...

متن کامل

Error Estimation in Large Spreadsheets using Bayesian Statistics

Spreadsheets are ubiquitous in business with the financial sector particularly heavily reliant on the technology. It is known that the level of spreadsheet error can be high and that it is often necessary to review spreadsheets based on a structured methodology which includes a cell by cell examination of the spreadsheet. This paper outlines the early research that has been carried out into the...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:
  • CoRR

دوره abs/0809.3609  شماره 

صفحات  -

تاریخ انتشار 2008